Learning ArcGIS Geodatabases by 2014

Author:2014
Language: eng
Format: mobi
Publisher: Packt Publishing

Note

Indexing is a feature that helps speed up data retrieval for an attribute or a collection of attributes in a database table.

Compressing is a process by which the duplicated data in geodatabase datasets are simplified to decrease their size.

Compacting is a process by which a frequently edited geodatabase is cleaned from unused and orphan records.

Geodatabase indexing

Indexing is the de facto optimization standard for databases. It is a very powerful and effective tool that can help speed up the retrieval of records. Without indexing, a table is scanned entirely to retrieve a particular record. So, if we have a dataset with n records, the worst-case scenario is that the record we are trying to locate is the last record in that table, and thus we need to search through n records in order to reach it. Imagine a feature class with a million features, and the time taken to visit each feature is 1 millisecond; this means we need 17 minutes to scan the entire dataset. Of course, the response time depends on the record you are looking for; if it is located at the beginning of the feature class, it will take less time to be located.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.